You can select top 5 records from your table by using sql server top(<number of rows>) function.
Here is an example, which selects top 5 records from table student_record.
select top(5) * from student_record
Liked By
Write Answer
Return Top Five Recodrs From Table
We use cookies to ensure you have the best browsing experience on our website. By using our site, you
acknowledge that you have read and understood our
Cookie Policy &
Privacy Policy
Join MindStick Community
You have need login or register for voting of answers or question.
Anonymous User
08-Oct-2010You can select top 5 records from your table by using sql server top(<number of rows>) function.
Here is an example, which selects top 5 records from table student_record.